<?php

echo '<table cellspacing=0 cellpadding=10><tr><td class ="noborder"><b>Assigned Jobs by Operator</b></td></tr>';

mysql_query("Select * From tblJobs where Assigned='Not Assigned' And Closed=' ' ");
echo "<td class='noborder'>Not Assigned : </td><td class='noborder'><b>", mysql_affected_rows() ,"</b></td>";

$result = mysql_query("SELECT * FROM tblUsers WHERE Username!='systemadmin'");
while($row = mysql_fetch_array($result))
{
mysql_query("Select * From tblJobs where Assigned='$row[Name]' And Closed=' ' ");
echo "<tr><td class='noborder'>".$row[Name]." : </td><td class='noborder'><b>", mysql_affected_rows() ,"</b></td><tr>";
}
echo '</table>';

?>